/*
 Navicat Premium Data Transfer

 Source Server         : dev-saas
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : rm-wz9u373k1o57z128s6o.mysql.rds.aliyuncs.com:3306
 Source Schema         : pipeline

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 07/01/2022 13:29:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_app
-- ----------------------------
DROP TABLE IF EXISTS `t_app`;
CREATE TABLE `t_app` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `app` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '应用',
  `lang` varchar(30) NOT NULL COMMENT '语言',
  `artifact` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '制品路径',
  `git` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'git地址',
  `pipeline_template` varchar(50) DEFAULT NULL COMMENT 'pipeline模版',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_app` (`app`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='APP表';

-- ----------------------------
-- Records of t_app
-- ----------------------------
BEGIN;
INSERT INTO `t_app` VALUES (1, 'mbserver', 'python', '', 'git@code.xiaoantech.com:xiaoantech/server/xcmbServer.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (2, 'ansible', 'ansible', 'target/boot.jar', 'git@gitee.com:mmbluex/boot.git', 'pipeline_ansible');
INSERT INTO `t_app` VALUES (3, 'distribution', 'java', 'distribution-service/target/distribution-service.jar', 'git@code.xiaoantech.com:gaowei/distribution.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (4, 'anfu', 'python', '', 'git@code.xiaoantech.com:xiaoantech/server/anfu.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (5, 'device', 'nodejs', '', 'git@code.xiaoantech.com:xiaoantech/server/DeviceServer.js.git', 'pipeline_nodejs');
INSERT INTO `t_app` VALUES (6, 'worker', 'nodejs', '', 'git@code.xiaoantech.com:xiaoantech/server/workerServer.git', 'pipeline_nodejs');
INSERT INTO `t_app` VALUES (7, 'ebike', 'nodejs', '', 'git@code.xiaoantech.com:xiaoantech/server/XCeBike.git', 'pipeline_nodejs');
INSERT INTO `t_app` VALUES (8, 'qifu-mbserver', 'python', '', 'git@code.xiaoantech.com:xiaoantech/server/xcmbServer.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (9, 'nodetest', 'nodejs', 'dist', 'git@code.xiaoantech.com:xiaoantech/server/XCeBike.git', 'pipeline_nodejs');
INSERT INTO `t_app` VALUES (10, 'release', 'release', '', '', 'pipeline_release');
INSERT INTO `t_app` VALUES (11, 'ebike-tenant', 'java', 'ebike-tenant-start/target/ebike-tenant-start.jar', 'git@code.xiaoantech.com:ebike/ebike-tenant.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (12, 'xiaoantech-fastid', 'java', 'xiaoantech-fastid-register/target/xiaoantech-fastid-register.jar', 'git@code.xiaoantech.com:java/xiaoantech-fastid.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (13, 'ebike-auth-business', 'java', 'ebike-auth-business-start/target/ebike-auth-business-start.jar', 'git@code.xiaoantech.com:ebike/ebike-auth-business.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (14, 'ebike-auth-client', 'java', 'ebike-auth-client-start/target/ebike-auth-client-start.jar', 'git@code.xiaoantech.com:ebike/ebike-auth-client.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (15, 'ebike-management', 'java', 'ebike-management-start/target/ebike-management-start.jar', 'git@code.xiaoantech.com:ebike/ebike-management.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (16, 'ebike-user', 'java', 'ebike-user-start/target/ebike-user-start.jar', 'git@code.xiaoantech.com:ebike/ebike-user.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (17, 'ebike-service-client', 'java', 'ebike-service-client-start/target/ebike-service-client-start.jar', 'git@code.xiaoantech.com:ebike/ebike-service-client.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (18, 'ebike-service-business', 'java', 'ebike-service-business-start/target/ebike-service-business-start.jar', 'git@code.xiaoantech.com:ebike/ebike-service-business.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (19, 'ebike-scheduler', 'java', 'ebike-scheduler-start/target/ebike-scheduler-start.jar', 'git@code.xiaoantech.com:ebike/ebike-scheduler.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (20, 'ebike-rent', 'java', 'ebike-rent-start/target/ebike-rent-start.jar', 'git@code.xiaoantech.com:ebike/ebike-rent.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (21, 'ebike-order', 'java', 'ebike-order-start/target/ebike-order-start.jar', 'git@code.xiaoantech.com:ebike/ebike-order.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (22, 'ebike-fence', 'java', 'ebike-fence-start/target/ebike-fence-start.jar', 'git@code.xiaoantech.com:ebike/ebike-fence.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (23, 'ebike-gateway-openapi', 'java', 'ebike-gateway-openapi-start/target/ebike-gateway-openapi-start.jar', 'git@code.xiaoantech.com:ebike/ebike-gateway-openapi.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (24, 'ebike-gateway-business', 'java', 'ebike-gateway-business-start/target/ebike-gateway-business-start.jar', 'git@code.xiaoantech.com:ebike/ebike-gateway-business.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (25, 'ebike-gateway-client', 'java', 'ebike-gateway-client-start/target/ebike-gateway-client-start.jar', 'git@code.xiaoantech.com:ebike/ebike-gateway-client.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (26, 'ebike-device-consume', 'java', 'ebike-device-consume-start/target/ebike-device-consume-start.jar', 'git@code.xiaoantech.com:ebike/ebike-device-consume.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (27, 'ebike-device-paas', 'java', 'ebike-device-paas-start/target/ebike-device-paas-start.jar', 'git@code.xiaoantech.com:ebike/ebike-device-paas.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (28, 'ebike-operation', 'python', '', 'git@code.xiaoantech.com:ebike/ebike-operation.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (29, 'ebike-account', 'python', '', 'git@code.xiaoantech.com:ebike/ebike-account.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (30, 'ebike-pay', 'python', '', 'git@code.xiaoantech.com:ebike/ebike-pay.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (31, 'ebike-visual', 'python', '', 'git@code.xiaoantech.com:ebike/ebike-visual.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (32, 'ebike-marketing', 'python', '', 'git@code.xiaoantech.com:ebike/ebike-marketing.git', 'pipeline_python');
INSERT INTO `t_app` VALUES (33, 'multi-service', 'java', 'multi-service/target/multi-service.jar', 'git@code.xiaoantech.com:ebike/MultiCenter.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (34, 'hasg-gateway', 'java', 'xa-standalone/target/xa-standalone.jar', 'git@code.xiaoantech.com:xiaoantech/server/HASG.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (35, 'anvelink', 'java', 'anvelink-bootstrap/target/anvelink-bootstrap-1.0.0-SNAPSHOT.jar', 'git@code.xiaoantech.com:xiaoantech/server/anvelink.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (36, 'anvelink-openapi', 'java', 'anvelink-device-bootstrap/target/anvelink-openapi-bootstrap.jar', 'git@code.xiaoantech.com:xiaoantech/server/anvelink-openapi.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (37, 'anvelink-worker', 'java', 'worker-bootstrap/target/anvelink-worker-bootstrap.jar', 'git@code.xiaoantech.com:xiaoantech/server/anvelink-worker.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (38, 'anvelink-pusher', 'java', 'anvelink-pusher-bootstrap/target/anvelink-pusher-bootstrap.jar', 'git@code.xiaoantech.com:xiaoantech/server/anvelink-pusher.git', 'pipeline_java');
INSERT INTO `t_app` VALUES (39, 'anvelink-console', 'java', 'anvelink-console-bootstrap/target/anvelink-console-bootstrap.jar', 'git@code.xiaoantech.com:xiaoantech/server/anvelink-console.git', 'pipeline_java');
COMMIT;

-- ----------------------------
-- Table structure for t_customer
-- ----------------------------
DROP TABLE IF EXISTS `t_customer`;
CREATE TABLE `t_customer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `customer_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '客户名称',
  `app` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'app',
  `runtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '运行环境[kubernetes、vm]',
  `kubeconfig` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部署在哪个k8s集群中',
  `pipeline_template` varchar(50) DEFAULT NULL COMMENT '指定模版',
  PRIMARY KEY (`id`),
  KEY `idx_cust_app` (`customer_name`,`app`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='APP表';

-- ----------------------------
-- Records of t_customer
-- ----------------------------
BEGIN;
INSERT INTO `t_customer` VALUES (1, 'led', 'device', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"xiaoan-test\",\"ns\":\"uat\"},\"prod\":{\"kubeconfig\":\"xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (2, 'led', 'anfu', 'vm', NULL, '');
INSERT INTO `t_customer` VALUES (3, 'xiaoan', 'ebike-gateway-openapi', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (4, 'xiaoan', 'anvelink', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (5, 'xiaoan', 'hasg-gateway', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (6, 'xiaoan', 'ebike-gateway', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (7, 'xiaoan', 'ebike-rent', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', '');
INSERT INTO `t_customer` VALUES (8, 'xiaoan', 'ebike-user', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (10, 'xiaoan', 'ebike-auth-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (11, 'xiaoan', 'ebike-auth-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (12, 'xiaoan', 'ebike-management', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (13, 'xiaoan', 'ebike-service-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (14, 'xiaoan', 'ebike-service-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (15, 'xiaoan', 'ebike-scheduler', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (16, 'xiaoan', 'ebike-order', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (17, 'xiaoan', 'ebike-fence', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (18, 'xiaoan', 'multi-service', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (19, 'xiaoan', 'ebike-gateway-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (20, 'xiaoan', 'ebike-gateway-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (21, 'xiaoan', 'ebike-device-consume', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (22, 'xiaoan', 'ebike-device-paas', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (23, 'xiaoan', 'ebike-tenant', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (24, 'xiaoan', 'xiaoantech-fastid', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (25, 'xiaoan', 'ebike-operation', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (26, 'xiaoan', 'ebike-account', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (27, 'xiaoan', 'ebike-pay', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (28, 'xiaoan', 'ebike-visual', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (29, 'xiaoan', 'ebike-marketing', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (30, 'bolan', 'ebike-rent', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (31, 'bolan', 'ebike-user', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (32, 'bolan', 'ebike-auth-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (33, 'bolan', 'ebike-gateway', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (34, 'bolan', 'ebike-auth-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (35, 'bolan', 'ebike-management', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (36, 'bolan', 'ebike-device-consume', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (37, 'bolan', 'ebike-gateway-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (38, 'bolan', 'ebike-service-client', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (39, 'bolan', 'ebike-service-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (40, 'bolan', 'ebike-scheduler', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (41, 'bolan', 'ebike-order', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (42, 'bolan', 'ebike-fence', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (43, 'bolan', 'ebike-gateway-business', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (44, 'bolan', 'ebike-account', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (45, 'bolan', 'ebike-pay', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (46, 'bolan', 'ebike-visual', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (47, 'bolan', 'ebike-marketing', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (48, 'bolan', 'ebike-operation', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (49, 'bolan', 'xiaoantech-fastid', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (50, 'bolan', 'ebike-tenant', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (51, 'bolan', 'ebike-device-paas', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (52, 'bolan', 'multi-service', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (53, 'xiaoan', 'anvelink-openapi', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (54, 'xiaoan', 'anvelink-worker', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (55, 'xiaoan', 'anvelink-pusher', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (56, 'xiaoan', 'anvelink-console', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (57, 'tcly', 'ebike-gateway-openapi', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"test\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"test\"},\"uat\":{\"kubeconfig\":\"Xiaoan-test\",\"ns\":\"dev\"},\"prod\":{\"kubeconfig\":\"Xiaoan-prod\",\"ns\":\"prod\"}}', NULL);
INSERT INTO `t_customer` VALUES (58, 'bolan', 'anvelink-openapi', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (59, 'bolan', 'anvelink-worker', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (60, 'bolan', 'anvelink-pusher', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (61, 'bolan', 'anvelink-console', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
INSERT INTO `t_customer` VALUES (62, 'bolan', 'hasg-gateway', 'kubernetes', '{\"dev\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"test\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"uat\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"},\"prod\":{\"kubeconfig\":\"bolan\",\"ns\":\"bolan\"}}', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_job_history
-- ----------------------------
DROP TABLE IF EXISTS `t_job_history`;
CREATE TABLE `t_job_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `app` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '应用',
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '租户',
  `build_id` int(30) NOT NULL COMMENT '构建ID',
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '操作人',
  `build_time` datetime DEFAULT NULL COMMENT '操作时间',
  `is_success` bigint(1) DEFAULT NULL COMMENT '是否成功',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='APP表';

-- ----------------------------
-- Records of t_job_history
-- ----------------------------
BEGIN;
INSERT INTO `t_job_history` VALUES (35, 'distribution', 'bolan', 72, '高伟', NULL, 1);
INSERT INTO `t_job_history` VALUES (36, 'distribution', 'xiaoan', 73, '高伟', NULL, 0);
INSERT INTO `t_job_history` VALUES (37, 'distribution', 'xiaoan', 74, '高伟', '2021-12-10 00:00:00', 0);
INSERT INTO `t_job_history` VALUES (38, 'distribution', 'xiaoan', 75, '高伟', '2021-12-10 12:53:50', 0);
INSERT INTO `t_job_history` VALUES (39, 'distribution', 'xiaoan', 78, '高伟', '2021-12-10 14:27:51', 0);
INSERT INTO `t_job_history` VALUES (40, 'distribution', 'xiaoan', 79, '高伟', '2021-12-10 14:32:53', 0);
INSERT INTO `t_job_history` VALUES (41, 'distribution', 'bolan', 80, '高伟', '2021-12-13 09:03:29', 1);
INSERT INTO `t_job_history` VALUES (42, 'ebike-rent', 'bolan', 81, '高伟', '2021-12-16 15:44:55', 0);
INSERT INTO `t_job_history` VALUES (43, 'ebike-rent', 'bolan', 82, '高伟', '2021-12-16 15:45:27', 1);
INSERT INTO `t_job_history` VALUES (44, 'ebike-rent', 'bolan', 83, '高伟', '2021-12-16 18:30:56', 1);
INSERT INTO `t_job_history` VALUES (45, 'ebike-gateway-openapi', 'tcly', 84, '高伟', '2021-12-20 14:10:37', 1);
INSERT INTO `t_job_history` VALUES (46, 'ebike-gateway-openapi', 'tcly', 85, '高伟', '2021-12-20 14:30:26', 1);
INSERT INTO `t_job_history` VALUES (47, 'ebike-gateway-openapi', 'tcly', 87, 'huwei', '2021-12-20 17:25:52', 1);
INSERT INTO `t_job_history` VALUES (48, 'multi-service', 'bolan', 90, '高伟', '2021-12-27 13:37:30', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
